SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001122s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 502576 LIMIT 1 [ RunTime:0.000309s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 502576 [ RunTime:0.001587s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (233720,858846,541538,582326,338342,768350,945210,986459,443239,923318,303196,803896,726482,396299,590041,569109,762728,222376,55694,851210,1047875,705070,403222,857010,347663,83025,428210,148841,314351,193626,823509,518484,943645,369592,809885,819467,275654,683633,1013207,141082,985022,874853,326806,475450,450864,868316,673872,938250,221335,676879,376409,626723,67610,24595,543209,126526,545980,73791,307468,494613) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001121s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 502576 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000402s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 502576 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000511s ]