SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001252s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 336309 LIMIT 1 [ RunTime:0.000345s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 336309 [ RunTime:0.001459s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (385254,658323,1039455,259918,883159,453024,984255,607260,201267,16618,645293,727100,397068,805573,1005816,820447,155234,560554,347391,331882,141456,629518,867386,1029370,575959,158330,763037,425321,648262,761606,798173,137435,516608,599150,971700,747689,104047,785799,161161,94819,250931,26808,959081,7402,939748,779139,652105,507777,66222,702923,450316,476618,1014095,1000292,145615,623603,442540,396199,550232,485905) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001369s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 336309 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000406s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 336309 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000400s ]