SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001288s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 48368 LIMIT 1 [ RunTime:0.000331s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 48368 [ RunTime:0.001774s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (107870,147806,874032,1004178,477675,319220,379934,191147,18111,962739,328089,1045424,767500,10675,608680,7577,856934,251663,91044,454679,1026220,565028,859693,933152,313043,858870,830768,601533,824206,597834,532392,569998,410574,283522,631634,1002122,426405,515834,457718,559752,721073,319360,130095,159873,871871,1011053,134469,1008094,336047,326419,315387,19736,959297,770841,630053,825070,312836,348354,423008,21196) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001020s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 48368 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000386s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 48368 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000645s ]