SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001593s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 563295 LIMIT 1 [ RunTime:0.000439s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 563295 [ RunTime:0.001533s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (185618,812073,206094,726547,437611,249967,928322,146491,324387,34169,357951,10069,788369,1040358,469350,835788,680852,498780,436675,873224,1032474,282046,326810,892096,453019,256405,795430,412930,677237,575067,959897,204149,1030705,588999,891686,380427,255821,793004,729243,130504,992958,203275,477076,121857,742642,291042,616992,240060,423885,581920,386676,187460,953825,658201,327403,398735,886767,374212,997417,345460) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001064s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 563295 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000484s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 563295 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000583s ]