SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001106s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 469211 LIMIT 1 [ RunTime:0.000303s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 469211 [ RunTime:0.002346s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (178121,823600,945494,504628,15775,622392,848615,82302,229174,27038,52585,474364,651235,383282,287766,66341,322018,1045851,611244,546358,880040,30985,394530,712505,77634,885056,7083,669122,123737,365094,863162,60542,322566,374186,180134,786881,939867,84652,880508,895150,1025663,942598,692988,694361,971423,669428,729346,193981,504678,373936,986983,942494,602534,276987,639257,308529,675208,16169,94994,639715) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000984s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 469211 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000353s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 469211 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000426s ]