SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001161s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 295198 LIMIT 1 [ RunTime:0.000334s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 295198 [ RunTime:0.002116s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (564594,867099,323862,40414,394839,929908,363576,790665,135996,830413,732159,284121,797403,67904,571265,670393,705293,692070,1041850,646550,985020,686828,488686,240776,483396,542073,425181,12365,663532,919595,1018411,678156,552186,169152,1001350,935516,310134,377749,640434,189837,760373,914975,7126,563568,794632,380592,1034745,546036,559302,889878,391583,879910,167213,319479,261812,653582,908880,890482,597226,26015) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001222s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 295198 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000428s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 295198 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000634s ]