SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001229s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 396133 LIMIT 1 [ RunTime:0.000347s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 396133 [ RunTime:0.002119s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (201363,361916,103558,632789,133214,60013,753164,1005003,294775,111063,402349,695942,410886,204101,13633,112463,657603,1011466,418507,835876,519543,903381,911414,16569,227715,956490,636658,117971,92934,1048716,493767,693661,332246,603111,953502,909884,283368,1042210,269573,206661,768209,6768,474469,1043323,298878,514065,878829,520809,640447,371748,58563,325626,991143,142118,61414,536232,276622,828571,880631,649786) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001280s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 396133 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000393s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 396133 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000584s ]