SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001185s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 190641 LIMIT 1 [ RunTime:0.000318s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 190641 [ RunTime:0.001506s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (435938,20186,1017235,510702,662486,806425,527418,336050,262283,240618,22816,530663,847270,850383,251054,771583,644374,359693,545684,542379,74714,393008,824109,636577,465819,553056,554641,314425,144095,292908,849677,324536,225791,1001326,37139,190940,959027,658661,256434,656477,408354,959627,379070,796932,788959,670205,319003,675490,422749,994829,702717,54270,712840,250037,414874,543218,900123,363318,816100,747196) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000971s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 190641 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000472s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 190641 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000571s ]