SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001267s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 472847 LIMIT 1 [ RunTime:0.000338s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 472847 [ RunTime:0.001653s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (562648,688146,542325,116168,409067,537075,869540,430808,255141,288102,639513,764111,596302,153266,967450,539607,448282,246237,788575,59400,745999,676175,600749,227337,147335,628815,263572,675306,42792,638753,501593,147175,518167,283144,373734,213528,856685,950264,225559,675338,205368,398824,1041465,512859,997991,913045,1004016,746848,1013391,48677,1021605,251315,579970,679201,984864,164465,362310,750145,680344,751025) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001432s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 472847 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000632s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 472847 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000426s ]