SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001158s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 69400 LIMIT 1 [ RunTime:0.000388s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 69400 [ RunTime:0.001941s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1045206,567552,251921,906544,469771,213870,522038,721183,37261,568659,792104,813361,534288,884486,191653,392559,344144,788914,761068,37022,305025,665303,554422,874512,678101,905394,108288,470252,328413,275663,953861,16357,755691,905778,211760,409526,1028208,6268,580817,831186,436640,493622,607608,706684,330500,140383,67919,450852,61857,64438,964169,77845,267282,360055,618730,771392,158245,333598,713751,328878) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000920s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 69400 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000488s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 69400 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000534s ]