SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001311s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 533997 LIMIT 1 [ RunTime:0.003265s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 533997 [ RunTime:0.002339s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1012911,780182,976959,840209,535519,768685,884523,488459,542978,912716,548940,276020,508691,768901,1028945,144544,536917,476799,953859,19201,955953,886227,527625,814649,194605,864160,216701,779291,225333,257705,380988,305739,399244,607112,760913,782197,516036,597891,73817,181680,569678,143462,206900,855802,374643,401696,375577,836610,82434,376744,218509,750813,447572,798670,111619,941341,751164,305203,357705,883488) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002782s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 533997 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002069s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 533997 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000633s ]