SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001184s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 403518 LIMIT 1 [ RunTime:0.000361s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 403518 [ RunTime:0.003677s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (143515,510311,266594,396841,4934,515545,252876,107793,1018053,610065,222997,526182,715097,170263,839055,458218,133128,489760,575870,209483,714063,267335,158546,597832,326312,976260,843472,804137,176732,707063,21823,603019,311394,777910,794899,334214,774719,428457,150316,327797,845795,442840,548971,339558,132465,759338,929158,479515,1041857,351562,850639,719982,793843,36956,982758,45026,174104,59959,991068,805241) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001143s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 403518 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000338s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 403518 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000519s ]