SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001161s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 482578 LIMIT 1 [ RunTime:0.000418s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 482578 [ RunTime:0.003141s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (277493,1038202,200974,80419,392530,870424,554728,584186,780870,137106,348124,364987,253937,43982,881249,611429,769442,881589,58401,1034279,128928,884349,376944,862901,201449,925221,781610,949454,777797,1010239,1044962,301017,597079,364606,146501,95697,49459,135519,749282,56883,689827,378633,941713,947109,448659,360301,410051,767490,292089,972815,184977,235845,281743,399539,1016610,440680,44984,1022356,283439,717745) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002754s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 482578 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001982s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 482578 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000619s ]