SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001212s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 589097 LIMIT 1 [ RunTime:0.000355s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 589097 [ RunTime:0.001561s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (838713,801020,904219,488776,764644,995039,838201,460153,734213,157321,461267,432680,633885,465728,92769,209478,841763,407001,382368,253114,342254,907003,345954,184675,748592,676492,457323,90883,363287,372922,72060,531079,133721,501826,668422,554545,678272,508227,139325,132610,465085,421325,116773,779388,514804,902243,446246,642513,12329,496217,227852,998887,581771,30085,750004,995854,769330,557837,865146,718410) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001303s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 589097 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000393s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 589097 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000503s ]