SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001664s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 427108 LIMIT 1 [ RunTime:0.000304s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 427108 [ RunTime:0.002640s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (728972,760081,129629,563829,360609,834936,58537,636189,181283,945808,912635,514664,744475,315535,454453,390600,1034943,155086,582041,907815,816816,122158,826433,821075,79461,181919,781761,656284,187143,981982,528928,683270,1000231,597766,76116,228346,269835,182088,370494,287391,147456,932358,158248,627120,746815,614653,377590,997275,123721,860150,788448,934867,932064,269213,267605,232123,76457,268405,67136,540432) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000971s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 427108 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000362s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 427108 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000428s ]