SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001324s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 545178 LIMIT 1 [ RunTime:0.000317s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 545178 [ RunTime:0.002331s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (49084,566636,133242,390423,1046359,538690,418631,521493,784900,858199,234314,614048,117521,44523,373743,426891,266641,911541,70832,21570,681205,732168,63452,527403,281631,1010126,486989,42705,660006,677974,105230,871183,863354,754542,858832,716191,274851,390355,614777,499658,363590,527418,1026325,524438,131734,466946,606133,880328,807619,128692,1039952,385448,400609,47841,635724,52939,389872,460592,353746,320278) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001485s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 545178 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000366s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 545178 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001434s ]