SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001120s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 404385 LIMIT 1 [ RunTime:0.000329s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 404385 [ RunTime:0.001732s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (547198,239302,253524,612467,393542,924798,520286,205431,423482,196786,255279,185642,859610,951069,343287,783339,945569,766711,180442,262109,609452,214065,51962,503065,834348,677146,415961,1006869,36130,632070,725683,692100,29694,174670,240560,624252,325708,464488,371750,487777,621751,125404,544234,727226,661007,888000,885734,664435,77453,479263,525034,282138,996422,706834,749282,837076,581279,664804,981835,256626) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000947s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 404385 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000327s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 404385 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000543s ]