SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001167s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 447224 LIMIT 1 [ RunTime:0.000303s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 447224 [ RunTime:0.001649s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (886237,833828,392566,1006473,811280,720813,762063,829428,851233,363382,923201,634704,383439,337123,710221,806566,489218,981423,27970,185554,383126,329662,504753,162647,420109,871395,278800,123478,887741,499275,105129,627286,836159,123162,4463,124578,498801,169845,648923,735459,685626,192270,641829,1013818,203351,613683,276500,239987,999795,31678,340351,902017,262273,333227,242803,827445,820873,548008,906678,534026) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001348s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 447224 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000340s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 447224 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000429s ]