SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001703s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 584413 LIMIT 1 [ RunTime:0.000670s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 584413 [ RunTime:0.002294s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (400673,783650,646262,489439,362681,51587,435506,335086,297791,963812,819056,480506,740711,266022,757534,1028531,960536,231490,33897,336394,1032685,169140,227061,138082,952146,979464,334881,396925,520035,331400,57372,842033,865362,324571,1042345,607593,337034,215996,410411,679430,898189,488,112153,941409,310851,46466,66625,452650,484733,844546,877341,134638,401777,610462,485924,340899,221105,786663,224012,738292) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001388s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 584413 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000664s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 584413 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000756s ]