SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001392s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 544847 LIMIT 1 [ RunTime:0.000404s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 544847 [ RunTime:0.001747s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (431207,318054,333686,971847,415464,216244,843118,1014155,468122,158400,244248,669212,642079,511511,905430,197876,441110,746834,906661,559476,444704,94142,461759,515199,65885,898035,655044,722748,156339,171509,687687,684650,602340,401756,761012,244734,102600,369,897713,242077,624526,88201,23961,171612,242587,306714,76654,189789,129012,103527,824392,551740,439059,267198,930731,821129,274828,142326,198471,213993) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001083s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 544847 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000733s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 544847 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001092s ]