SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001684s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 574214 LIMIT 1 [ RunTime:0.000348s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 574214 [ RunTime:0.002044s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1013031,901715,615965,525742,1013188,68978,222271,752481,614733,941004,538071,313647,980759,1024830,495451,658602,306593,497852,938571,783721,855969,931192,126085,333427,693596,758152,993244,638048,900615,714694,687287,273541,328550,229681,515126,847383,537830,421755,211273,289289,129504,178871,809240,758230,735132,510143,943712,45872,443404,581525,727182,971301,160337,572435,306219,675694,860570,798636,917762,469048) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001334s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 574214 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000399s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 574214 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000591s ]