SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001221s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 40470 LIMIT 1 [ RunTime:0.000369s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 40470 [ RunTime:0.002830s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1666,571744,33599,13073,414691,687068,213665,421325,249166,359879,284016,693390,290883,59603,354825,653421,380411,130173,1036773,39224,991520,850231,548264,298839,138445,946287,751294,828829,133095,329439,671263,995427,755423,120650,471903,1041365,1047277,914236,250443,347878,683774,124883,732157,64855,202385,43390,868886,897437,911784,229730,848458,728385,661654,589724,1017256,918141,270335,827493,59588,1023826) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001237s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 40470 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000353s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 40470 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000722s ]