SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001222s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 450311 LIMIT 1 [ RunTime:0.000357s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 450311 [ RunTime:0.001517s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (501290,819336,497024,176917,578376,915499,789709,932625,928728,425589,792856,970068,115865,623987,966204,957292,809335,829628,1024460,67856,1019172,584680,749611,878122,364746,397714,591997,669925,462662,548987,103365,807057,1018924,83535,80879,777902,687772,82384,792867,71375,335674,1027800,187697,39675,87308,730508,732993,489622,291485,836215,894226,839849,42427,1029246,484881,356445,243620,1004593,689317,493947) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001030s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 450311 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000365s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 450311 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000538s ]