SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001141s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 104570 LIMIT 1 [ RunTime:0.000300s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 104570 [ RunTime:0.001510s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (19742,268400,924034,491104,396760,741685,594973,15209,820418,456222,159396,850336,317257,489369,342817,143495,7646,24662,48693,334295,1048107,92900,1043713,878786,198779,975835,3055,1028633,901108,234623,177422,243260,248459,322979,410246,803144,124176,914291,1047942,265244,665717,688063,697185,644936,602770,647385,836526,506726,905577,577676,607606,654619,208320,998678,597669,1048352,537380,180381,258093,423421) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000995s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 104570 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000355s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 104570 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000479s ]