SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001159s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 296801 LIMIT 1 [ RunTime:0.000340s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 296801 [ RunTime:0.002411s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (366551,275800,502048,465487,334449,942062,551999,59414,490645,826154,469255,294327,200411,223531,116653,594180,468199,265160,797983,850443,167210,160395,423317,788186,377031,120917,329813,262439,738348,560260,820736,43518,903687,254926,578977,833049,947024,68802,1047628,764447,772492,909721,578521,154563,128431,923077,732433,989421,740695,144690,1021477,845195,190340,512519,660201,120653,414738,146105,1005171,989668) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001029s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 296801 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000342s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 296801 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000581s ]