SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001394s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 609810 LIMIT 1 [ RunTime:0.000531s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 609810 [ RunTime:0.002106s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (442896,100273,90257,172489,418060,277499,863671,211587,201633,540802,200939,603356,18076,290759,885632,224371,535380,173145,469842,721038,223459,877043,726910,582905,357848,118990,102816,370704,1004495,165809,68867,990797,383002,190561,452113,231476,672825,830099,747383,165428,977920,348924,862365,307146,441071,560386,318432,704405,4506,1024974,374572,934204,340008,594239,819826,84176,500363,798660,130574,162806) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001634s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 609810 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000738s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 609810 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002185s ]