SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001441s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 53470 LIMIT 1 [ RunTime:0.000357s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 53470 [ RunTime:0.001623s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (430709,193980,472971,535722,14294,985891,244216,842864,64660,111073,953725,152999,657471,21750,517731,169028,703440,112750,445250,641893,498077,996468,143882,486116,17217,574400,456340,758752,305912,812462,110924,818930,782158,408032,515598,194796,725195,89829,145059,1026456,1008593,361144,276598,493484,375127,642099,517259,338764,420557,459888,629796,467535,689031,156677,1023275,136736,455879,1046264,87517,332019) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001187s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 53470 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000355s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 53470 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000533s ]