SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001129s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 414393 LIMIT 1 [ RunTime:0.000317s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 414393 [ RunTime:0.001844s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (934203,255725,437597,52499,185112,737468,77735,171067,121254,392803,1015909,381688,305311,462200,531760,60958,1036404,384940,374975,727848,922202,458443,434377,304678,638324,733069,363211,650004,592841,423649,791404,700218,816174,605130,519924,918725,894687,285616,718836,391083,242679,937152,389536,183946,83432,718920,984831,266780,810421,822974,634604,543438,605108,927222,734901,440105,504760,400597,1048441,234596) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001348s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 414393 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000430s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 414393 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000532s ]