SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001178s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 462012 LIMIT 1 [ RunTime:0.000557s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 462012 [ RunTime:0.001974s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (439869,518905,39406,39159,695090,793084,548945,37888,574713,507777,415302,352933,702865,795647,655063,246344,622813,199683,694202,363641,14531,719705,177759,984476,811975,172810,224582,968755,402930,929218,8809,201166,425991,642004,428930,346278,316896,126434,16586,258267,894926,404881,860674,383549,392408,875939,736717,240594,699750,890503,386879,807376,657526,1046221,603033,854668,995393,148165,109194,1030067) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003217s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 462012 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000469s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 462012 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000632s ]