SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001162s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 454719 LIMIT 1 [ RunTime:0.000295s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 454719 [ RunTime:0.001977s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (603242,187218,530293,216775,942610,222718,949652,793125,634647,349644,1014841,335667,396754,997258,921936,1023160,169565,329738,837554,227404,817946,817,652709,157557,943453,888916,281857,412444,995848,33449,281614,802335,185365,531859,706787,345137,186796,941561,669850,600293,359287,300766,353304,763773,590558,552688,576264,201925,713649,613803,647208,211438,487189,12409,205766,916874,97210,363901,531936,780830) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001013s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 454719 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000374s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 454719 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000402s ]