SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001188s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 318895 LIMIT 1 [ RunTime:0.000347s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 318895 [ RunTime:0.001667s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (401298,378298,874585,628491,720852,980234,216586,335302,467579,1046934,99954,656102,262772,112946,666197,542840,427313,184561,942988,458859,701969,1029191,480975,589666,683071,74505,22147,639692,240897,217168,1037329,769803,918298,407032,859911,786590,774481,407163,926448,284020,423513,418977,571608,165444,40420,719855,664605,355784,227460,1007767,865377,385830,135656,577992,1007367,548635,561160,584562,124567,750006) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001158s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 318895 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000393s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 318895 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000557s ]