SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001125s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1015301 LIMIT 1 [ RunTime:0.000322s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1015301 [ RunTime:0.001877s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (741675,76949,253795,318187,975516,294091,721206,21821,587824,126945,176411,566415,1020145,422784,170305,108606,956630,173448,545521,926997,923722,625628,515066,947571,280259,325408,633353,261440,953735,188952,721622,716583,849484,916121,1030285,76533,59543,48679,590050,33738,376989,242733,134870,79899,971752,109085,262117,128724,106104,976469,303060,771665,645859,188848,665682,251949,657895,487824,1038793,839140) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001019s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1015301 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000514s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1015301 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000579s ]