SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.000955s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 803254 LIMIT 1 [ RunTime:0.000331s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 803254 [ RunTime:0.001948s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (304010,423688,10486,810134,762559,207492,320609,480458,683308,864664,292975,924041,818281,631639,965430,293639,1000552,1013971,262018,461434,748173,251020,730963,49267,998106,753792,448311,932738,658244,677321,308223,712906,844983,299512,69661,818667,596075,1009133,630506,456124,750177,246711,274308,281050,662066,680439,6348,144689,293476,80980,716758,879568,876024,74864,763898,176176,973386,832008,484533,184440) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001566s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 803254 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000501s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 803254 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000561s ]