SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.005196s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1029702 LIMIT 1 [ RunTime:0.002640s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1029702 [ RunTime:0.003545s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (526071,629169,864353,625614,745495,252666,588715,1013159,511353,45822,858572,168805,916957,596599,488311,881444,368671,669376,587875,381069,143406,768610,143699,179412,439979,229426,580028,122053,445803,17269,750757,972940,543909,846758,140683,615839,743196,562107,179977,491259,613364,1023748,438576,966863,315281,753951,904375,242829,915069,283842,994958,508778,232736,848757,962618,947410,948153,276695,568287,541386) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002098s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1029702 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000551s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1029702 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000441s ]