SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001253s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 543654 LIMIT 1 [ RunTime:0.000351s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 543654 [ RunTime:0.002526s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (431430,234616,219192,585424,1022640,358132,682174,301209,564468,662278,692500,1023485,140851,400973,302848,197152,143852,77931,213163,804314,298101,31817,927303,1035799,383852,414953,999612,823583,578896,39073,811318,317069,1004190,715000,707855,404598,283942,970464,12551,436492,672260,821738,229731,913939,371298,236434,494162,269040,180183,169785,243254,149496,797664,41657,254259,701773,483218,808978,709880,326909) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000936s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 543654 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000376s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 543654 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000548s ]