SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001172s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1010428 LIMIT 1 [ RunTime:0.000308s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1010428 [ RunTime:0.001956s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (654864,395552,416374,371067,154496,560901,412470,801443,704836,566019,325643,999982,149968,746365,417737,73655,244949,707113,435354,701704,935044,25432,462927,87841,994642,961005,707810,113364,441163,29359,245678,612086,258755,927879,1044866,758850,644796,779164,944242,574073,558314,306202,865620,987583,400471,886572,766541,1028845,912162,935644,871103,21986,52169,554664,720539,109808,789208,731307,346470,192982) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001131s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1010428 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000369s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1010428 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000530s ]