SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002945s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 283209 LIMIT 1 [ RunTime:0.003737s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 283209 [ RunTime:0.007561s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (500727,716086,722159,222061,602473,298651,882608,60841,808044,504201,383538,770275,447763,823869,231955,255238,226799,1023939,905360,148439,867739,1040878,911029,259253,821081,632844,967859,492110,376465,107012,683065,587993,979467,258530,864854,500720,772194,932209,132150,802796,460709,370775,441836,298697,286568,200219,389996,59663,1026531,786740,685349,659159,352066,801162,520932,453956,50899,796819,30877,292151) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004141s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 283209 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000399s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 283209 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002058s ]