SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001797s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 480416 LIMIT 1 [ RunTime:0.000597s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 480416 [ RunTime:0.002904s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (521049,899986,529988,666934,930556,286509,125799,849611,980684,591442,353879,953496,347087,415826,181122,898456,349675,686702,531380,409090,530484,910278,684333,373176,65825,156840,324506,857992,394352,257631,719957,403562,106282,532060,590047,574220,295614,424617,423223,313478,267698,145511,621358,62312,546257,373710,247614,344298,767220,606710,905138,393854,644233,192955,8505,133949,726242,769642,981625,747755) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003121s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 480416 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000891s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 480416 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000549s ]