SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001301s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 10393 LIMIT 1 [ RunTime:0.000398s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 10393 [ RunTime:0.001753s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (759940,572506,626634,169659,689602,376268,291492,508601,256063,82143,557041,235132,58310,636958,832631,791579,267497,1010621,146509,329246,949793,531654,532578,662823,690460,752706,305050,400723,300990,850233,945120,267087,918707,460818,812035,969956,545729,704079,337756,233069,52000,1021224,221335,32255,551677,806701,459483,897849,375500,654818,975750,1033248,248375,261109,446199,155181,901627,197032,353593,866840) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000986s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 10393 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000365s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 10393 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000709s ]