SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001070s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 396271 LIMIT 1 [ RunTime:0.000373s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 396271 [ RunTime:0.001773s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (198403,437559,32875,620018,817747,184530,629965,601019,65094,77108,542210,201605,572228,159354,38022,780115,311537,551103,872783,32763,968850,278925,216052,831409,669799,665253,124887,729268,970640,87722,11787,872530,929464,304081,967663,532794,737690,36994,936763,325112,427655,95763,111379,124223,670316,443879,650005,445655,421711,731847,373034,817429,617415,97797,522076,587126,147832,590485,559244,922802) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001080s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 396271 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000454s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 396271 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000449s ]