SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001193s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1040019 LIMIT 1 [ RunTime:0.000396s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1040019 [ RunTime:0.001501s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (359805,310540,276789,650751,604478,542133,818227,107609,859002,78279,141914,753212,423109,568734,1010825,817137,296907,453542,273817,607389,1037696,273322,577391,536288,51619,984205,849239,890203,688165,527214,192807,327426,905213,635446,534134,234028,951439,553140,227829,787893,312220,432143,285612,1038445,998073,325860,653293,327943,814167,873361,94463,236019,928430,266609,911517,432635,50249,226120,953509,198928) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002386s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1040019 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000634s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1040019 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000450s ]