SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001244s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 813611 LIMIT 1 [ RunTime:0.000350s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 813611 [ RunTime:0.002179s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (166040,76912,479717,824475,912231,750670,559727,727713,746252,834854,168437,826571,40689,398708,640656,1039905,116346,633385,269518,625145,893058,236083,176368,544681,568037,705387,623174,480623,367721,681285,160012,825521,219210,946537,321389,1001945,767820,137554,23494,57792,161549,298453,417718,1008658,105863,1000459,818534,581328,62277,684987,787949,901422,767540,905603,831877,885147,276261,878388,847784,732533) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001084s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 813611 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000370s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 813611 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000457s ]