SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001739s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 540776 LIMIT 1 [ RunTime:0.000394s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 540776 [ RunTime:0.001991s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (292882,347430,88301,676323,561320,838500,4884,203090,465585,454432,671534,901612,6877,174436,670603,753911,173574,390845,840480,101470,230605,465985,971718,338297,835139,566475,896651,993548,401494,852559,793675,1039426,365636,305811,209132,618373,926698,489852,1023345,60617,912069,155561,764342,189444,508674,626683,427433,142590,161371,373771,799293,711059,336944,785290,476411,216191,961950,593160,193746,89924) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001133s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 540776 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000416s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 540776 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000619s ]