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` = 841213 LIMIT 1 [ RunTime:0.000474s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 841213 [ RunTime:0.004771s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (362212,135889,1009938,577818,115729,949977,551487,564686,151294,23436,915669,873783,16383,673445,122579,648503,37463,864576,396059,1022725,97772,443842,955777,737965,235760,908581,914316,550084,76206,975793,63220,913797,893154,165878,212764,775161,167270,796601,754106,912165,129138,834867,601378,98917,1033100,538828,953550,602441,842117,859778,207927,408126,488583,47032,48997,1034936,390373,779389,314353,690254) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001466s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 841213 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000365s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 841213 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001298s ]