SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001085s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 901754 LIMIT 1 [ RunTime:0.000315s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 901754 [ RunTime:0.001670s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (191534,1021743,665856,108367,702159,174345,127951,476664,168026,111291,575580,899432,304333,935500,588427,46127,783907,619809,135281,162357,18575,827152,283738,68094,481765,680130,779891,292751,431753,869351,716173,887741,656800,746161,637717,28747,473808,598208,495533,1017843,815975,224092,1030356,13993,390668,705577,374392,162761,870725,577071,45807,600604,342144,715233,247867,245219,355136,300536,717616,597934) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001095s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 901754 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000363s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 901754 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000520s ]