SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001429s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 197498 LIMIT 1 [ RunTime:0.003887s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 197498 [ RunTime:0.004089s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (830856,459094,405692,719135,360922,518208,770800,1047796,536461,309460,623213,811405,417390,791603,742504,98554,779202,701937,337839,627392,790788,116568,9248,507589,131210,754673,278834,681817,89243,462159,902152,113510,232182,562520,539687,62929,552902,307469,1014283,812479,37510,360368,887090,403901,263398,811469,302196,198162,221067,114630,364948,339892,228182,955414,8930,749971,200536,657895,848855,574058) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002631s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 197498 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002786s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 197498 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003090s ]