SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001152s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1036947 LIMIT 1 [ RunTime:0.000302s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1036947 [ RunTime:0.001570s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (731843,193971,332968,372947,881734,416549,819062,736018,42649,898541,927815,69913,428830,99929,679887,962069,538725,662717,220784,634473,480956,597295,221189,431962,146048,199597,269640,169579,595248,28646,943958,686820,789260,413139,386471,982581,763998,174867,640710,848027,228335,410694,549810,127408,1014423,959916,370031,133807,126187,235115,207793,469298,64216,1022859,600890,509925,344033,229881,469589,241570) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001038s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1036947 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000357s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1036947 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000607s ]