SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001180s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 262876 LIMIT 1 [ RunTime:0.000429s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 262876 [ RunTime:0.002737s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (982518,639522,679751,621565,59317,926027,520976,421874,1021038,482672,341979,1042643,273524,824391,365338,856781,402541,116061,223907,590585,359544,362111,233699,536044,131766,404212,196798,615839,94726,261622,874855,898943,749713,60297,166558,886467,902373,558524,172500,555585,763824,662644,648401,746383,920720,632484,11916,667663,1040107,474952,379517,329026,226233,968682,271661,790038,947998,594422,169151,340682) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001278s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 262876 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000370s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 262876 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000600s ]