SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001160s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 580091 LIMIT 1 [ RunTime:0.000552s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 580091 [ RunTime:0.001816s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (191878,529165,329185,98825,577850,52319,235861,591654,121346,772247,620880,40319,756697,986016,814392,372095,636349,315254,845974,185873,1043240,569971,1038120,1001753,192309,738446,942096,182591,1024200,637983,1026134,304364,224896,373221,783046,588849,169645,39663,977996,854633,271576,263144,557939,627719,500312,323592,324748,416791,690926,666225,970856,34981,788072,29587,297364,303156,497459,451942,357122,791092) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001064s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 580091 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000417s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 580091 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000439s ]