SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001240s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1019373 LIMIT 1 [ RunTime:0.004242s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1019373 [ RunTime:0.005189s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (40664,101096,786786,409367,393648,405408,751714,632447,590788,767169,177482,541058,810882,248269,268421,349127,143504,894106,200684,726277,793128,274228,669206,738425,648305,802167,127826,291045,920516,181145,960553,618127,183482,389541,122444,756472,273840,183833,514378,830831,505394,246502,493825,209627,890707,285424,42944,571019,201132,1045858,130664,723717,805857,214999,911846,102281,676693,794489,708422,700787) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002108s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1019373 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003035s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1019373 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000545s ]