SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001277s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 485012 LIMIT 1 [ RunTime:0.000475s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 485012 [ RunTime:0.002344s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (919863,241722,764671,262695,815506,887245,14320,466774,553321,971702,234557,709618,227998,964062,816046,273251,638510,959148,852792,692350,1013712,59166,921937,601849,364187,866031,689160,742637,65677,399612,140572,520024,447108,201198,147750,710153,155753,331001,474793,358998,180321,316198,205800,799267,475505,412016,579298,621206,544025,197266,225231,636038,859175,783166,1037735,671308,149842,944014,205592,243806) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001136s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 485012 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000386s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 485012 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000540s ]