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` = 469531 LIMIT 1 [ RunTime:0.000340s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 469531 [ RunTime:0.002210s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (728375,459502,983398,630989,248329,949291,192832,684813,971816,242993,897964,720601,626208,358068,37657,308740,857166,202789,196907,1040200,111902,797224,265056,344828,365716,99302,65406,28269,298930,985023,1036159,425471,323676,25645,929535,142288,827830,822806,155108,509338,928774,572415,725989,1041289,25725,356329,727276,139074,736586,354393,912068,945614,22040,854420,627913,1015103,1017411,48794,409345,131448) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001053s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 469531 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000365s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 469531 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000676s ]