SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001124s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 801823 LIMIT 1 [ RunTime:0.000305s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 801823 [ RunTime:0.001730s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (782994,172704,774703,1043142,217127,98997,815846,58185,931598,1015682,673268,443541,387091,1023103,560862,943738,853050,891454,1015050,355785,253357,908883,1027238,272113,103314,509790,845580,100905,262616,818995,554839,325390,820473,478853,777231,305946,1006205,929013,400531,1020275,753729,915200,45444,184937,372813,903536,3804,701079,747938,326978,424233,570873,763616,328028,775529,561838,476039,138807,73986,49098) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001010s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 801823 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000360s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 801823 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001035s ]