SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001152s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1001604 LIMIT 1 [ RunTime:0.000392s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1001604 [ RunTime:0.001911s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (438076,959679,346715,35037,403694,1028401,1019748,725545,406793,991954,516488,583165,1000696,185589,302633,807565,891351,897670,534997,963772,75296,603067,973661,391416,406811,136402,19604,142001,566817,345430,891460,766996,391108,51941,689541,295982,170559,702445,415638,605258,859167,902694,378173,617395,849576,1037539,207706,546271,816245,232936,466458,695647,76101,579068,213582,112479,426335,1042245,814849,588352) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001202s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1001604 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000445s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1001604 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000610s ]