SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001270s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 553705 LIMIT 1 [ RunTime:0.000343s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 553705 [ RunTime:0.001584s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (832470,952101,181975,506078,211619,633630,278866,383162,156580,862416,604491,894462,489117,865363,115807,722357,543518,732067,74140,254962,76190,932466,831420,208811,106142,357079,257186,72390,325719,386333,712972,1004569,1015146,1014714,637828,33808,143061,352991,164245,658017,650183,724701,928942,762581,311803,1029383,558848,330441,300227,728264,578156,575930,18182,1032687,621009,483073,774864,145030,567786,561960) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001190s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 553705 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000391s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 553705 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000623s ]