SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001265s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 191180 LIMIT 1 [ RunTime:0.001534s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 191180 [ RunTime:0.002849s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1003616,219601,365607,860118,119958,47120,877253,897076,1042566,840442,732375,795074,680421,230012,643511,231015,98630,845746,649507,729882,572759,581974,1001842,924242,697298,266359,74052,713384,470897,43443,762628,656784,942514,593736,55934,784365,275203,174656,307484,82089,789584,376124,805333,252635,761806,282549,259679,394785,233605,7689,901949,379828,140966,134454,251900,264962,487537,243290,319663,993903) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001287s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 191180 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000388s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 191180 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000661s ]