SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001158s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 484210 LIMIT 1 [ RunTime:0.000338s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 484210 [ RunTime:0.001622s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (355271,668546,730962,587359,27716,850880,379678,847965,885057,450113,801368,676743,839037,681872,744467,645444,1043961,938984,32010,463107,1034421,407233,10541,662671,536909,512770,562006,536328,2187,146743,992849,979315,248208,983829,838687,1039018,504412,647910,928337,810815,374828,425101,1043757,118038,920492,889190,656209,629776,462134,175404,309417,106585,660867,18458,612909,109587,426433,664152,389859,293274) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001126s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 484210 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000354s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 484210 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000571s ]