SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001182s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 108040 LIMIT 1 [ RunTime:0.000365s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 108040 [ RunTime:0.002004s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (210051,581941,1029587,465400,372089,63628,700601,616903,770140,888331,802471,667598,117746,615950,227538,733781,732503,239267,391168,797287,318562,585531,857639,738562,570119,1015705,786302,153989,484225,247571,462950,985960,229800,870233,489464,77868,280668,466798,488424,199892,449941,417562,188712,998119,954730,962614,512772,1037071,98922,130572,929097,449565,491482,735431,573990,775328,960564,564147,827382,589956) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001155s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 108040 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000350s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 108040 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003792s ]