SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001151s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 101615 LIMIT 1 [ RunTime:0.000394s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 101615 [ RunTime:0.002687s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (690836,949739,828235,544518,635637,286431,531691,497666,169941,1017134,951896,756387,973011,321870,175233,139949,537768,380188,702510,46072,958822,163645,746109,307164,936276,589171,921676,1028178,263316,208751,213745,676624,835572,377656,517400,991181,34360,27917,830945,788792,845187,537238,835137,155883,922414,826689,721957,802759,746549,275147,412898,484864,258884,457623,776506,726671,563599,88756,111138,1031179) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001046s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 101615 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000390s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 101615 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000543s ]