SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001141s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 282482 LIMIT 1 [ RunTime:0.000331s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 282482 [ RunTime:0.002430s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (928773,1012616,110998,702880,7592,259185,246018,96056,476541,306788,236106,514990,182520,200297,721888,895997,648835,242763,62975,110078,818974,117161,26920,597518,281471,118587,470607,242837,998049,75177,902666,604811,93637,139201,324233,772169,476229,81408,2325,56915,421736,881316,248059,389642,5530,422950,3774,587178,984316,86298,534785,13520,799974,709341,1024579,879067,909559,479592,176609,904766) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001040s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 282482 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000365s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 282482 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000454s ]