SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001143s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 544959 LIMIT 1 [ RunTime:0.000326s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 544959 [ RunTime:0.002306s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (532541,752552,794419,1037622,792362,614979,510347,336854,461496,657631,14053,1040922,906575,166238,765426,23748,474308,289428,274980,865771,359283,596933,321374,788061,780734,993236,683046,725982,108409,436534,478840,307764,230240,350092,116182,580063,506834,139941,664346,609254,1037705,36404,346401,96944,51152,861745,127375,678823,354990,490679,264779,500428,509011,730876,502722,541758,836853,439208,396142,785458) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001997s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 544959 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001610s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 544959 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000499s ]