SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001192s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 578323 LIMIT 1 [ RunTime:0.001376s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 578323 [ RunTime:0.001732s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (252305,342846,616780,414110,698363,307164,9495,806884,901970,761678,611530,568518,72586,149276,27850,972797,208124,701935,393481,689700,835380,12063,390774,799469,365255,628565,544122,35601,592988,450486,964753,938905,938788,66614,504039,884250,953623,891202,718023,555192,823503,644304,16989,752142,205893,597109,290445,270249,724934,775849,544055,67483,634968,562696,624134,848677,204359,403979,345255,675203) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001380s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 578323 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000550s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 578323 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000468s ]