SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001161s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 407501 LIMIT 1 [ RunTime:0.000356s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 407501 [ RunTime:0.001794s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (534717,383334,396639,824849,83868,376645,237644,45916,899372,145126,447279,791549,877996,27431,18095,944116,618291,942779,142015,150013,366429,911493,239799,925524,487389,439773,27507,666333,343285,987130,539053,697089,329181,396422,547939,223793,397490,321751,193325,73662,897232,281594,131324,228082,1015402,395542,272176,1002455,178457,398702,985163,473343,147454,537630,509365,762952,973593,115953,1022942,1035669) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000990s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 407501 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000414s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 407501 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000659s ]