SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001127s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 501150 LIMIT 1 [ RunTime:0.000321s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 501150 [ RunTime:0.001639s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (282493,205082,265551,463637,888800,680367,1021261,666705,399962,970263,305577,911330,557878,366659,406924,149573,652976,606684,279771,238262,788323,446408,671382,510078,587580,524812,583372,407565,193277,123005,986830,775229,496226,782045,1017068,388729,840677,236705,598472,921585,864496,1018870,833403,992058,791913,1036049,614503,347928,172632,644072,466760,704209,346459,342969,133818,917432,833123,826353,478509,869416) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001144s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 501150 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000378s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 501150 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000554s ]