SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001226s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 558014 LIMIT 1 [ RunTime:0.000310s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 558014 [ RunTime:0.001768s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1026574,700961,209029,164393,417566,798955,214226,356036,8868,467950,368396,447277,806958,1048093,276498,1032623,726754,725628,682718,1041325,610161,625748,108879,635825,731805,391633,897843,140946,383198,244548,584831,909357,894467,359009,258508,965161,62822,886795,125249,175121,2871,830649,566623,761503,142943,611242,750404,906464,540408,670551,250721,713657,330440,946692,164958,872931,876120,202643,365295,419478) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001166s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 558014 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000345s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 558014 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000545s ]